Expresso Churn Data Report

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	10839
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 MiB
Average record size in memory	249.0 B

Variable types

Text	1
Numeric	16
Categorical	2

Alerts

`MRG` has constant value "0"	Constant
`ARPU_SEGMENT` is highly overall correlated with `FREQUENCE` and 6 other fields	High correlation
`FREQUENCE` is highly overall correlated with `ARPU_SEGMENT` and 4 other fields	High correlation
`FREQUENCE_RECH` is highly overall correlated with `ARPU_SEGMENT` and 4 other fields	High correlation
`FREQ_TOP_PACK` is highly overall correlated with `ARPU_SEGMENT` and 4 other fields	High correlation
`MONTANT` is highly overall correlated with `ARPU_SEGMENT` and 6 other fields	High correlation
`ON_NET` is highly overall correlated with `ORANGE`	High correlation
`ORANGE` is highly overall correlated with `ARPU_SEGMENT` and 4 other fields	High correlation
`REGULARITY` is highly overall correlated with `ARPU_SEGMENT` and 2 other fields	High correlation
`REVENUE` is highly overall correlated with `ARPU_SEGMENT` and 6 other fields	High correlation
`TIGO` is highly overall correlated with `ORANGE`	High correlation
`CHURN` is highly imbalanced (98.4%)	Imbalance
`user_id` has unique values	Unique
`REGION` has 6731 (62.1%) zeros	Zeros
`DATA_VOLUME` has 2260 (20.9%) zeros	Zeros
`ON_NET` has 203 (1.9%) zeros	Zeros
`TIGO` has 775 (7.2%) zeros	Zeros
`ZONE1` has 3558 (32.8%) zeros	Zeros
`ZONE2` has 3141 (29.0%) zeros	Zeros

Reproduction

Analysis started	2025-04-19 13:46:50.057794
Analysis finished	2025-04-19 13:47:05.097324
Duration	15.04 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

user_id
Text

Unique

Distinct	10839
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Length

Max length	40
Median length	40
Mean length	40
Min length	40

Characters and Unicode

Total characters	433560
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10839 ?
Unique (%)	100.0%

Sample

1st row	00000bfd7d50f01092811bc0c8d7b0d6fe7c3596
2nd row	000134b94b87f70dc30597aa19598fbeaa70dc7f
3rd row	0004f3a6671684d984c83c2cfa30647665dd430b
4th row	001191f7d3aec518be9fcd550015fb45826c3ed2
5th row	0013b5ca16d87ad1d286fe66d46754b80b9e22fc

Value	Count	Frequency (%)
003d653c4f398826e80d4c00934e8b494c35d0fb	1	< 0.1%
fff8b64302bda7f59ff196af759e1de7c4215f6d	1	< 0.1%
00000bfd7d50f01092811bc0c8d7b0d6fe7c3596	1	< 0.1%
000134b94b87f70dc30597aa19598fbeaa70dc7f	1	< 0.1%
0004f3a6671684d984c83c2cfa30647665dd430b	1	< 0.1%
001191f7d3aec518be9fcd550015fb45826c3ed2	1	< 0.1%
0013b5ca16d87ad1d286fe66d46754b80b9e22fc	1	< 0.1%
ff94c0dc594556f211bba78587c20ad8c278128b	1	< 0.1%
ffa95fe39c8d39e420d5a48e2fceb635b28bca86	1	< 0.1%
ffab6191020103260404e50115f1cf3d0b0a4390	1	< 0.1%
Other values (10829)	10829	99.9%

Most occurring characters

Value	Count	Frequency (%)
d	27416	6.3%
0	27349	6.3%
3	27327	6.3%
8	27265	6.3%
c	27226	6.3%
e	27195	6.3%
b	27152	6.3%
4	27129	6.3%
f	27049	6.2%
a	27044	6.2%
Other values (6)	161408	37.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	433560	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	27416	6.3%
0	27349	6.3%
3	27327	6.3%
8	27265	6.3%
c	27226	6.3%
e	27195	6.3%
b	27152	6.3%
4	27129	6.3%
f	27049	6.2%
a	27044	6.2%
Other values (6)	161408	37.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	433560	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	27416	6.3%
0	27349	6.3%
3	27327	6.3%
8	27265	6.3%
c	27226	6.3%
e	27195	6.3%
b	27152	6.3%
4	27129	6.3%
f	27049	6.2%
a	27044	6.2%
Other values (6)	161408	37.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	433560	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	27416	6.3%
0	27349	6.3%
3	27327	6.3%
8	27265	6.3%
c	27226	6.3%
e	27195	6.3%
b	27152	6.3%
4	27129	6.3%
f	27049	6.2%
a	27044	6.2%
Other values (6)	161408	37.2%

REGION
Real number (ℝ)

Zeros

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1235354

Minimum	0
Maximum	13
Zeros	6731
Zeros (%)	62.1%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	7
95-th percentile	12
Maximum	13
Range	13
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.5633025
Coefficient of variation (CV)	1.4609415
Kurtosis	-0.590438
Mean	3.1235354
Median Absolute Deviation (MAD)	0
Skewness	1.0379363
Sum	33856
Variance	20.82373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	6731	62.1%
12	965	8.9%
9	768	7.1%
4	577	5.3%
11	378	3.5%
6	327	3.0%
7	280	2.6%
13	220	2.0%
1	167	1.5%
2	138	1.3%
Other values (4)	288	2.7%

Value	Count	Frequency (%)
0	6731	62.1%
1	167	1.5%
2	138	1.3%
3	136	1.3%
4	577	5.3%
5	5	< 0.1%
6	327	3.0%
7	280	2.6%
8	115	1.1%
9	768	7.1%

Value	Count	Frequency (%)
13	220	2.0%
12	965	8.9%
11	378	3.5%
10	32	0.3%
9	768	7.1%
8	115	1.1%
7	280	2.6%
6	327	3.0%
5	5	< 0.1%
4	577	5.3%

TENURE
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.8721284

Minimum	0
Maximum	7
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	7
median	7
Q3	7
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.64484914
Coefficient of variation (CV)	0.093835432
Kurtosis	35.183921
Mean	6.8721284
Median Absolute Deviation (MAD)	0
Skewness	-5.7262475
Sum	74487
Variance	0.41583041
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
7	10341	95.4%
5	203	1.9%
4	101	0.9%
3	66	0.6%
6	60	0.6%
2	57	0.5%
1	9	0.1%
0	2	< 0.1%

Value	Count	Frequency (%)
0	2	< 0.1%
1	9	0.1%
2	57	0.5%
3	66	0.6%
4	101	0.9%
5	203	1.9%
6	60	0.6%
7	10341	95.4%

Value	Count	Frequency (%)
7	10341	95.4%
6	60	0.6%
5	203	1.9%
4	101	0.9%
3	66	0.6%
2	57	0.5%
1	9	0.1%
0	2	< 0.1%

MONTANT
Real number (ℝ)

High correlation

Distinct	1224
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16442.896

Minimum	200
Maximum	235000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	200
5-th percentile	3100
Q1	7800
median	13000
Q3	20900
95-th percentile	41005
Maximum	235000
Range	234800
Interquartile range (IQR)	13100

Descriptive statistics

Standard deviation	13816.041
Coefficient of variation (CV)	0.84024378
Kurtosis	28.209639
Mean	16442.896
Median Absolute Deviation (MAD)	6050
Skewness	3.5236476
Sum	1.7822455 × 10⁸
Variance	1.9088299 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	107	1.0%
9500	106	1.0%
12000	103	1.0%
13000	101	0.9%
5500	100	0.9%
15000	98	0.9%
10500	95	0.9%
5000	94	0.9%
7000	93	0.9%
12500	91	0.8%
Other values (1214)	9851	90.9%

Value	Count	Frequency (%)
200	1	< 0.1%
400	1	< 0.1%
500	11	0.1%
550	1	< 0.1%
600	4	< 0.1%
700	7	0.1%
800	2	< 0.1%
850	2	< 0.1%
900	5	< 0.1%
1000	24	0.2%

Value	Count	Frequency (%)
235000	1	< 0.1%
215000	1	< 0.1%
214000	1	< 0.1%
198000	1	< 0.1%
194800	1	< 0.1%
161000	1	< 0.1%
156746	1	< 0.1%
141000	1	< 0.1%
135500	1	< 0.1%
133000	1	< 0.1%

FREQUENCE_RECH
Real number (ℝ)

High correlation

Distinct	106
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.111818

Minimum	1
Maximum	131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	12
median	23
Q3	38
95-th percentile	65
Maximum	131
Range	130
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	19.025954
Coefficient of variation (CV)	0.7017587
Kurtosis	0.7822502
Mean	27.111818
Median Absolute Deviation (MAD)	12
Skewness	1.0214575
Sum	293865
Variance	361.98694
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	293	2.7%
5	285	2.6%
10	281	2.6%
16	280	2.6%
12	278	2.6%
15	273	2.5%
18	270	2.5%
13	267	2.5%
14	264	2.4%
9	259	2.4%
Other values (96)	8089	74.6%

Value	Count	Frequency (%)
1	48	0.4%
2	114	1.1%
3	216	2.0%
4	231	2.1%
5	285	2.6%
6	293	2.7%
7	252	2.3%
8	246	2.3%
9	259	2.4%
10	281	2.6%

Value	Count	Frequency (%)
131	1	< 0.1%
113	1	< 0.1%
112	1	< 0.1%
109	1	< 0.1%
103	1	< 0.1%
101	1	< 0.1%
100	3	< 0.1%
99	3	< 0.1%
98	2	< 0.1%
97	2	< 0.1%

REVENUE
Real number (ℝ)

High correlation

Distinct	7753
Distinct (%)	71.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16732.591

Minimum	198
Maximum	226150
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	198
5-th percentile	3244.1
Q1	7998
median	13352
Q3	21217
95-th percentile	41512.9
Maximum	226150
Range	225952
Interquartile range (IQR)	13219

Descriptive statistics

Standard deviation	13975.664
Coefficient of variation (CV)	0.83523607
Kurtosis	24.88136
Mean	16732.591
Median Absolute Deviation (MAD)	6248
Skewness	3.3588567
Sum	1.8136456 × 10⁸
Variance	1.9531918 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12000	19	0.2%
6500	17	0.2%
4000	17	0.2%
5500	17	0.2%
11000	17	0.2%
9500	16	0.1%
8000	15	0.1%
10000	15	0.1%
7000	15	0.1%
4500	15	0.1%
Other values (7743)	10676	98.5%

Value	Count	Frequency (%)
198	1	< 0.1%
249	1	< 0.1%
301	1	< 0.1%
314	1	< 0.1%
494	1	< 0.1%
500	2	< 0.1%
501	1	< 0.1%
509	1	< 0.1%
510	1	< 0.1%
511	1	< 0.1%

Value	Count	Frequency (%)
226150	1	< 0.1%
221999	1	< 0.1%
221695	1	< 0.1%
168738	1	< 0.1%
161749	1	< 0.1%
159640	1	< 0.1%
137318	1	< 0.1%
136500	1	< 0.1%
135189	1	< 0.1%
129082	1	< 0.1%

ARPU_SEGMENT
Real number (ℝ)

High correlation

Distinct	5809
Distinct (%)	53.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5577.5322

Minimum	66
Maximum	75383
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	66
5-th percentile	1081.7
Q1	2666
median	4451
Q3	7072.5
95-th percentile	13837.3
Maximum	75383
Range	75317
Interquartile range (IQR)	4406.5

Descriptive statistics

Standard deviation	4658.5543
Coefficient of variation (CV)	0.83523575
Kurtosis	24.881254
Mean	5577.5322
Median Absolute Deviation (MAD)	2083
Skewness	3.3588545
Sum	60454871
Variance	21702128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1833	33	0.3%
4000	32	0.3%
1000	31	0.3%
1500	31	0.3%
2000	28	0.3%
2667	26	0.2%
2333	26	0.2%
3000	25	0.2%
3833	24	0.2%
4833	24	0.2%
Other values (5799)	10559	97.4%

Value	Count	Frequency (%)
66	1	< 0.1%
83	1	< 0.1%
100	1	< 0.1%
105	1	< 0.1%
165	1	< 0.1%
167	3	< 0.1%
170	3	< 0.1%
171	1	< 0.1%
183	1	< 0.1%
200	1	< 0.1%

Value	Count	Frequency (%)
75383	1	< 0.1%
74000	1	< 0.1%
73898	1	< 0.1%
56246	1	< 0.1%
53916	1	< 0.1%
53213	1	< 0.1%
45773	1	< 0.1%
45500	1	< 0.1%
45063	1	< 0.1%
43027	1	< 0.1%

FREQUENCE
Real number (ℝ)

High correlation

Distinct	91
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.330012

Minimum	1
Maximum	91
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	18
median	30
Q3	45
95-th percentile	70
Maximum	91
Range	90
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	19.076706
Coefficient of variation (CV)	0.5723582
Kurtosis	-0.10624188
Mean	33.330012
Median Absolute Deviation (MAD)	13
Skewness	0.6914411
Sum	361264
Variance	363.9207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	251	2.3%
18	250	2.3%
23	250	2.3%
21	248	2.3%
31	243	2.2%
34	235	2.2%
13	232	2.1%
24	231	2.1%
28	228	2.1%
19	228	2.1%
Other values (81)	8443	77.9%

Value	Count	Frequency (%)
1	6	0.1%
2	16	0.1%
3	47	0.4%
4	61	0.6%
5	93	0.9%
6	106	1.0%
7	146	1.3%
8	150	1.4%
9	198	1.8%
10	181	1.7%

Value	Count	Frequency (%)
91	14	0.1%
90	10	0.1%
89	11	0.1%
88	18	0.2%
87	20	0.2%
86	20	0.2%
85	17	0.2%
84	19	0.2%
83	23	0.2%
82	29	0.3%

DATA_VOLUME
Real number (ℝ)

Zeros

Distinct	6139
Distinct (%)	56.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7301.9184

Minimum	0
Maximum	201413
Zeros	2260
Zeros (%)	20.9%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	2082
Q3	9562
95-th percentile	30642.8
Maximum	201413
Range	201413
Interquartile range (IQR)	9558

Descriptive statistics

Standard deviation	12869.652
Coefficient of variation (CV)	1.7625028
Kurtosis	30.104045
Mean	7301.9184
Median Absolute Deviation (MAD)	2082
Skewness	4.2050909
Sum	79145493
Variance	1.6562793 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2260	20.9%
1	292	2.7%
2	103	1.0%
3	42	0.4%
4	36	0.3%
5	32	0.3%
6	26	0.2%
7	19	0.2%
11	17	0.2%
20	15	0.1%
Other values (6129)	7997	73.8%

Value	Count	Frequency (%)
0	2260	20.9%
1	292	2.7%
2	103	1.0%
3	42	0.4%
4	36	0.3%
5	32	0.3%
6	26	0.2%
7	19	0.2%
8	9	0.1%
9	15	0.1%

Value	Count	Frequency (%)
201413	1	< 0.1%
182985	1	< 0.1%
169758	1	< 0.1%
165225	1	< 0.1%
157418	1	< 0.1%
144532	1	< 0.1%
140012	1	< 0.1%
126272	1	< 0.1%
125018	1	< 0.1%
122333	1	< 0.1%

ON_NET
Real number (ℝ)

High correlation Zeros

Distinct	1845
Distinct (%)	17.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	432.54784

Minimum	0
Maximum	19950
Zeros	203
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	19
median	88
Q3	354
95-th percentile	1884.3
Maximum	19950
Range	19950
Interquartile range (IQR)	335

Descriptive statistics

Standard deviation	1117.1308
Coefficient of variation (CV)	2.5826757
Kurtosis	83.73012
Mean	432.54784
Median Absolute Deviation (MAD)	82
Skewness	7.4380319
Sum	4688386
Variance	1247981.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	251	2.3%
2	236	2.2%
0	203	1.9%
3	194	1.8%
4	181	1.7%
5	159	1.5%
6	147	1.4%
8	147	1.4%
7	136	1.3%
9	122	1.1%
Other values (1835)	9063	83.6%

Value	Count	Frequency (%)
0	203	1.9%
1	251	2.3%
2	236	2.2%
3	194	1.8%
4	181	1.7%
5	159	1.5%
6	147	1.4%
7	136	1.3%
8	147	1.4%
9	122	1.1%

Value	Count	Frequency (%)
19950	1	< 0.1%
19832	1	< 0.1%
19820	1	< 0.1%
18287	1	< 0.1%
17533	1	< 0.1%
17121	1	< 0.1%
17016	1	< 0.1%
16973	1	< 0.1%
16841	1	< 0.1%
15292	1	< 0.1%

ORANGE
Real number (ℝ)

High correlation

Distinct	1183
Distinct (%)	10.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	234.34736

Minimum	0
Maximum	5543
Zeros	64
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	38
median	116
Q3	296
95-th percentile	826
Maximum	5543
Range	5543
Interquartile range (IQR)	258

Descriptive statistics

Standard deviation	348.50146
Coefficient of variation (CV)	1.487115
Kurtosis	30.715644
Mean	234.34736
Median Absolute Deviation (MAD)	95
Skewness	4.3299714
Sum	2540091
Variance	121453.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	117	1.1%
3	103	1.0%
2	96	0.9%
7	92	0.8%
5	86	0.8%
8	86	0.8%
14	85	0.8%
12	82	0.8%
10	80	0.7%
4	79	0.7%
Other values (1173)	9933	91.6%

Value	Count	Frequency (%)
0	64	0.6%
1	117	1.1%
2	96	0.9%
3	103	1.0%
4	79	0.7%
5	86	0.8%
6	72	0.7%
7	92	0.8%
8	86	0.8%
9	77	0.7%

Value	Count	Frequency (%)
5543	1	< 0.1%
4877	1	< 0.1%
4107	1	< 0.1%
3965	1	< 0.1%
3953	1	< 0.1%
3939	1	< 0.1%
3771	1	< 0.1%
3637	1	< 0.1%
3605	1	< 0.1%
3558	1	< 0.1%

TIGO
Real number (ℝ)

High correlation Zeros

Distinct	422
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.49368

Minimum	0
Maximum	2144
Zeros	775
Zeros (%)	7.2%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	11
Q3	35
95-th percentile	156
Maximum	2144
Range	2144
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	86.058411
Coefficient of variation (CV)	2.358173
Kurtosis	106.14089
Mean	36.49368
Median Absolute Deviation (MAD)	10
Skewness	8.088495
Sum	395555
Variance	7406.0501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1033	9.5%
0	775	7.2%
2	732	6.8%
3	557	5.1%
4	423	3.9%
5	394	3.6%
6	356	3.3%
7	303	2.8%
8	290	2.7%
9	232	2.1%
Other values (412)	5744	53.0%

Value	Count	Frequency (%)
0	775	7.2%
1	1033	9.5%
2	732	6.8%
3	557	5.1%
4	423	3.9%
5	394	3.6%
6	356	3.3%
7	303	2.8%
8	290	2.7%
9	232	2.1%

Value	Count	Frequency (%)
2144	1	< 0.1%
1613	1	< 0.1%
1471	1	< 0.1%
1456	1	< 0.1%
1306	1	< 0.1%
1302	1	< 0.1%
1289	1	< 0.1%
1275	1	< 0.1%
1249	1	< 0.1%
1109	1	< 0.1%

ZONE1
Real number (ℝ)

Zeros

Distinct	240
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.8772027

Minimum	0
Maximum	1609
Zeros	3558
Zeros (%)	32.8%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	35
Maximum	1609
Range	1609
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	49.879415
Coefficient of variation (CV)	5.0499536
Kurtosis	316.97404
Mean	9.8772027
Median Absolute Deviation (MAD)	1
Skewness	15.013475
Sum	107059
Variance	2487.956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3558	32.8%
1	2400	22.1%
2	1243	11.5%
3	643	5.9%
4	465	4.3%
5	335	3.1%
6	238	2.2%
7	187	1.7%
8	159	1.5%
9	144	1.3%
Other values (230)	1467	13.5%

Value	Count	Frequency (%)
0	3558	32.8%
1	2400	22.1%
2	1243	11.5%
3	643	5.9%
4	465	4.3%
5	335	3.1%
6	238	2.2%
7	187	1.7%
8	159	1.5%
9	144	1.3%

Value	Count	Frequency (%)
1609	1	< 0.1%
1427	1	< 0.1%
1206	1	< 0.1%
1204	1	< 0.1%
1133	1	< 0.1%
900	1	< 0.1%
883	1	< 0.1%
859	1	< 0.1%
793	1	< 0.1%
772	1	< 0.1%

ZONE2
Real number (ℝ)

Zeros

Distinct	199
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2854507

Minimum	0
Maximum	1324
Zeros	3141
Zeros (%)	29.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	6
95-th percentile	42
Maximum	1324
Range	1324
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	29.901377
Coefficient of variation (CV)	3.2202397
Kurtosis	443.69882
Mean	9.2854507
Median Absolute Deviation (MAD)	2
Skewness	14.931957
Sum	100645
Variance	894.09234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3141	29.0%
1	2002	18.5%
2	1050	9.7%
3	748	6.9%
4	527	4.9%
5	388	3.6%
6	296	2.7%
7	254	2.3%
8	167	1.5%
11	145	1.3%
Other values (189)	2121	19.6%

Value	Count	Frequency (%)
0	3141	29.0%
1	2002	18.5%
2	1050	9.7%
3	748	6.9%
4	527	4.9%
5	388	3.6%
6	296	2.7%
7	254	2.3%
8	167	1.5%
9	143	1.3%

Value	Count	Frequency (%)
1324	1	< 0.1%
702	1	< 0.1%
641	1	< 0.1%
585	1	< 0.1%
516	1	< 0.1%
503	1	< 0.1%
407	1	< 0.1%
396	1	< 0.1%
394	1	< 0.1%
383	1	< 0.1%

MRG
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	698.6 KiB

0	10839

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10839
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	10839	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	10839	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	10839	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	10839	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	10839	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	10839	100.0%

REGULARITY
Real number (ℝ)

High correlation

Distinct	60
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.306394

Minimum	1
Maximum	62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	1
5-th percentile	33
Q1	52
median	60
Q3	62
95-th percentile	62
Maximum	62
Range	61
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	10.06016
Coefficient of variation (CV)	0.18189868
Kurtosis	3.8472636
Mean	55.306394
Median Absolute Deviation (MAD)	2
Skewness	-1.9850036
Sum	599466
Variance	101.20682
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	4080	37.6%
61	1091	10.1%
60	652	6.0%
59	532	4.9%
58	404	3.7%
57	351	3.2%
56	301	2.8%
55	254	2.3%
54	228	2.1%
53	227	2.1%
Other values (50)	2719	25.1%

Value	Count	Frequency (%)
1	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
6	2	< 0.1%
7	2	< 0.1%
8	3	< 0.1%
9	4	< 0.1%
10	6	0.1%
11	8	0.1%
12	5	< 0.1%

Value	Count	Frequency (%)
62	4080	37.6%
61	1091	10.1%
60	652	6.0%
59	532	4.9%
58	404	3.7%
57	351	3.2%
56	301	2.8%
55	254	2.3%
54	228	2.1%
53	227	2.1%

TOP_PACK
Real number (ℝ)

Distinct	68
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.224375

Minimum	0
Maximum	67
Zeros	26
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	7
median	17
Q3	37
95-th percentile	56
Maximum	67
Range	67
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	18.067956
Coefficient of variation (CV)	0.77797383
Kurtosis	-0.73913925
Mean	23.224375
Median Absolute Deviation (MAD)	10
Skewness	0.76150373
Sum	251729
Variance	326.45104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	3013	27.8%
21	1110	10.2%
10	795	7.3%
51	779	7.2%
47	560	5.2%
37	546	5.0%
11	541	5.0%
29	482	4.4%
44	478	4.4%
13	357	3.3%
Other values (58)	2178	20.1%

Value	Count	Frequency (%)
0	26	0.2%
1	142	1.3%
2	17	0.2%
3	6	0.1%
4	3	< 0.1%
5	212	2.0%
6	22	0.2%
7	3013	27.8%
8	85	0.8%
9	2	< 0.1%

Value	Count	Frequency (%)
67	14	0.1%
66	211	1.9%
65	69	0.6%
64	3	< 0.1%
63	123	1.1%
62	3	< 0.1%
61	4	< 0.1%
60	1	< 0.1%
59	11	0.1%
58	10	0.1%

FREQ_TOP_PACK
Real number (ℝ)

High correlation

Distinct	138
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.780054

Minimum	1
Maximum	560
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	13
Q3	25
95-th percentile	56
Maximum	560
Range	559
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	20.025398
Coefficient of variation (CV)	1.0663121
Kurtosis	68.950022
Mean	18.780054
Median Absolute Deviation (MAD)	8
Skewness	4.6204338
Sum	203557
Variance	401.01658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	643	5.9%
2	548	5.1%
4	499	4.6%
5	478	4.4%
1	428	3.9%
6	427	3.9%
7	426	3.9%
9	418	3.9%
8	391	3.6%
10	367	3.4%
Other values (128)	6214	57.3%

Value	Count	Frequency (%)
1	428	3.9%
2	548	5.1%
3	643	5.9%
4	499	4.6%
5	478	4.4%
6	427	3.9%
7	426	3.9%
8	391	3.6%
9	418	3.9%
10	367	3.4%

Value	Count	Frequency (%)
560	1	< 0.1%
350	1	< 0.1%
286	1	< 0.1%
258	1	< 0.1%
257	1	< 0.1%
214	1	< 0.1%
206	1	< 0.1%
198	1	< 0.1%
193	1	< 0.1%
174	1	< 0.1%

CHURN
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	698.6 KiB

0	10823
1	16

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10839
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10839	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	10823	99.9%
1	16	0.1%

	ARPU_SEGMENT	CHURN	DATA_VOLUME	FREQUENCE	FREQUENCE_RECH	FREQ_TOP_PACK	MONTANT	ON_NET	ORANGE	REGION	REGULARITY	REVENUE	TENURE	TIGO	TOP_PACK	ZONE1	ZONE2
ARPU_SEGMENT	1.000	0.000	0.281	0.712	0.685	0.608	0.978	0.343	0.549	-0.172	0.532	1.000	0.010	0.411	-0.066	0.211	0.302
CHURN	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.107	0.000	0.000	0.011	0.000	0.000	0.000
DATA_VOLUME	0.281	0.000	1.000	0.223	0.171	0.112	0.268	-0.190	-0.089	-0.257	0.287	0.281	-0.042	-0.028	0.059	-0.081	0.026
FREQUENCE	0.712	0.000	0.223	1.000	0.914	0.778	0.709	0.155	0.239	-0.122	0.446	0.712	-0.025	0.193	0.021	0.028	0.216
FREQUENCE_RECH	0.685	0.000	0.171	0.914	1.000	0.806	0.685	0.177	0.240	-0.096	0.396	0.685	-0.023	0.195	-0.064	0.026	0.203
FREQ_TOP_PACK	0.608	0.000	0.112	0.778	0.806	1.000	0.599	0.243	0.338	-0.042	0.385	0.608	-0.010	0.247	-0.062	0.040	0.058
MONTANT	0.978	0.000	0.268	0.709	0.685	0.599	1.000	0.344	0.547	-0.165	0.530	0.978	0.010	0.410	-0.063	0.209	0.302
ON_NET	0.343	0.000	-0.190	0.155	0.177	0.243	0.344	1.000	0.594	0.156	0.371	0.343	0.057	0.431	0.178	0.123	-0.088
ORANGE	0.549	0.000	-0.089	0.239	0.240	0.338	0.547	0.594	1.000	-0.011	0.361	0.549	0.055	0.557	-0.008	0.165	-0.015
REGION	-0.172	0.000	-0.257	-0.122	-0.096	-0.042	-0.165	0.156	-0.011	1.000	-0.029	-0.172	-0.008	-0.040	0.058	-0.052	-0.153
REGULARITY	0.532	0.107	0.287	0.446	0.396	0.385	0.530	0.371	0.361	-0.029	1.000	0.532	0.022	0.288	0.057	0.070	0.038
REVENUE	1.000	0.000	0.281	0.712	0.685	0.608	0.978	0.343	0.549	-0.172	0.532	1.000	0.010	0.411	-0.066	0.211	0.302
TENURE	0.010	0.000	-0.042	-0.025	-0.023	-0.010	0.010	0.057	0.055	-0.008	0.022	0.010	1.000	0.045	0.004	0.026	-0.003
TIGO	0.411	0.011	-0.028	0.193	0.195	0.247	0.410	0.431	0.557	-0.040	0.288	0.411	0.045	1.000	-0.018	0.104	0.007
TOP_PACK	-0.066	0.000	0.059	0.021	-0.064	-0.062	-0.063	0.178	-0.008	0.058	0.057	-0.066	0.004	-0.018	1.000	-0.127	-0.048
ZONE1	0.211	0.000	-0.081	0.028	0.026	0.040	0.209	0.123	0.165	-0.052	0.070	0.211	0.026	0.104	-0.127	1.000	0.079
ZONE2	0.302	0.000	0.026	0.216	0.203	0.058	0.302	-0.088	-0.015	-0.153	0.038	0.302	-0.003	0.007	-0.048	0.079	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	user_id	REGION	TENURE	MONTANT	FREQUENCE_RECH	REVENUE	ARPU_SEGMENT	FREQUENCE	DATA_VOLUME	ON_NET	ORANGE	TIGO	ZONE1	ZONE2	REGULARITY	TOP_PACK	FREQ_TOP_PACK
0	00000bfd7d50f01092811bc0c8d7b0d6fe7c3596	2	7	4250.0	15.0	4251.0	1417.0	17.0	4.0	388.0	46.0	1.0	1.0	2.0	54	51	8.0
37	000134b94b87f70dc30597aa19598fbeaa70dc7f	0	7	10400.0	24.0	10900.0	3633.0	26.0	11815.0	12.0	59.0	3.0	0.0	1.0	54	21	8.0
170	0004f3a6671684d984c83c2cfa30647665dd430b	0	7	3000.0	6.0	2999.0	1000.0	7.0	515.0	15.0	0.0	0.0	0.0	0.0	58	21	5.0
561	001191f7d3aec518be9fcd550015fb45826c3ed2	12	7	2750.0	6.0	2748.0	916.0	6.0	0.0	33.0	1.0	22.0	0.0	8.0	39	47	1.0
635	0013b5ca16d87ad1d286fe66d46754b80b9e22fc	0	7	11700.0	21.0	12698.0	4233.0	33.0	2.0	170.0	249.0	15.0	6.0	3.0	62	7	17.0
1231	00254fdf431af60f3eaa471b6fd9347b85625e26	0	7	18000.0	41.0	18293.0	6098.0	55.0	30438.0	291.0	267.0	8.0	4.0	6.0	61	17	33.0
1254	002608756e211251f6ad3b8d0c7d17760db171e2	12	7	8700.0	4.0	10203.0	3401.0	14.0	15248.0	1318.0	354.0	27.0	0.0	0.0	62	37	3.0
2026	003d653c4f398826e80d4c00934e8b494c35d0fb	4	7	2900.0	13.0	3562.0	1187.0	20.0	0.0	269.0	59.0	25.0	1.0	0.0	52	51	14.0
2496	004beb0fb6ab1bb7f01295c892f6deac3c611609	0	7	36250.0	69.0	37551.0	12517.0	83.0	5977.0	80.0	35.0	22.0	0.0	32.0	61	29	58.0
2618	004fa2506a51129955773d197c43f36642b6b529	0	7	18650.0	40.0	18588.0	6196.0	45.0	6776.0	10.0	41.0	1.0	5.0	32.0	59	29	20.0

	user_id	REGION	TENURE	MONTANT	FREQUENCE_RECH	REVENUE	ARPU_SEGMENT	FREQUENCE	DATA_VOLUME	ON_NET	ORANGE	TIGO	ZONE1	ZONE2	REGULARITY	TOP_PACK	FREQ_TOP_PACK
2151840	ffbc92b18c368927ef3cbf94b8bfaa9d8933f8d3	0	7	14650.0	32.0	14470.0	4823.0	39.0	27089.0	66.0	32.0	1.0	9.0	1.0	54	17	11.0
2151920	ffbecdb24391bd0bb8e42eaa1f5bdd328083e203	9	5	56700.0	77.0	57399.0	19133.0	66.0	0.0	596.0	1300.0	32.0	15.0	22.0	62	7	96.0
2152085	ffc34a4c7b0e5d3bff7e7bb1932fcc1071d16dbc	9	7	14850.0	47.0	15950.0	5317.0	51.0	3827.0	7270.0	409.0	1.0	0.0	3.0	62	10	26.0
2152224	ffc7cc878f857dcf0e8b62d42ebf314bbf9f8b4d	0	7	35000.0	29.0	35497.0	11832.0	31.0	1564.0	57.0	17.0	4.0	304.0	4.0	61	1	29.0
2152322	ffcb0039e1cee9535d70450f7f37d047151e6ebf	0	7	18700.0	39.0	19348.0	6449.0	48.0	10735.0	206.0	266.0	28.0	0.0	0.0	62	7	18.0
2152712	ffd68ad289fd2d46347b7b48619671d532da12fa	0	7	12100.0	28.0	11661.0	3887.0	25.0	0.0	204.0	218.0	36.0	0.0	1.0	57	33	8.0
2153142	ffe457524394dca68e4d8ce1b2a096682d1ae879	8	5	3000.0	12.0	2989.0	996.0	18.0	4590.0	3.0	48.0	6.0	0.0	0.0	40	17	6.0
2153483	ffee32230918433bcbac7cd6d9004fe79ef95053	0	7	12000.0	8.0	11539.0	3846.0	9.0	9179.0	1405.0	384.0	42.0	0.0	2.0	61	37	3.0
2153547	fff01392a3349a53a2936bf35ed25db7f11db14e	0	7	14600.0	27.0	15599.0	5200.0	29.0	0.0	32.0	304.0	13.0	2.0	2.0	52	7	28.0
2153831	fff8b64302bda7f59ff196af759e1de7c4215f6d	0	7	40000.0	5.0	23197.0	7732.0	18.0	662.0	1143.0	568.0	75.0	47.0	12.0	61	34	1.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample